package com.fowo.api.model.shop;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import javax.validation.constraints.*;
import lombok.Data;

/** 利润查询报表-店铺 导入导出辅助模型 */
@Data
public class ShopProfitReportExcelPo {

  @Size(max = 50, message = "日期长度不能超过20")
  @DateTimeFormat("yyyy年MM月dd日")
  @ExcelProperty(value = "日期")
  private java.util.Date postedDateLocale;

  @ExcelProperty(value = "销量")
  private Integer totalSalesQuantity;

  @Size(max = 50, message = "补（换）货量长度不能超过20")
  @ExcelProperty(value = "补（换）货量")
  private Integer totalReshipQuantity;

  @ExcelProperty(value = "广告销售额")
  private java.math.BigDecimal totalAdsSales;

  @Size(max = 50, message = "店铺长度不能超过20")
  @ExcelProperty(value = "店铺")
  private String storeName;

  @ExcelProperty(value = "广告销量")
  private Integer totalAdsSalesQuantity;

  @ExcelProperty(value = "销售额")
  private java.math.BigDecimal totalSalesAmount;

  @ExcelProperty(value = "多渠道销量")
  private Integer mcFbaFulfillmentFeesQuantity;

  @ExcelProperty(value = "买家运费")
  private java.math.BigDecimal shippingCredits;

  @ExcelProperty(value = "促销折扣")
  private java.math.BigDecimal promotionalRebates;

  @ExcelProperty(value = "FBA库存赔偿")
  private java.math.BigDecimal fbaInventoryCredit;

  @ExcelProperty(value = "COD")
  private java.math.BigDecimal cashOnDelivery;

  @ExcelProperty(value = "其他收入")
  private java.math.BigDecimal otherInAmount;

  @ExcelProperty(value = "收入退款额")
  private java.math.BigDecimal totalSalesRefunds;

  @ExcelProperty(value = "费用退款额")
  private java.math.BigDecimal totalFeeRefunds;

  @ExcelProperty(value = "退款量")
  private Integer refundsQuantity;

  @ExcelProperty(value = "退款率")
  private java.math.BigDecimal refundsRate;

  @ExcelProperty(value = "退货量")
  private Integer fbaReturnsQuantity;

  @ExcelProperty(value = "退货率")
  private java.math.BigDecimal fbaReturnsQuantityRate;

  @ExcelProperty(value = "平台费")
  private java.math.BigDecimal platformFee;

  @ExcelProperty(value = "FBA发货费")
  private java.math.BigDecimal fbaDeliveryFee;

  @ExcelProperty(value = "其他订单费用")
  private java.math.BigDecimal otherTransactionFees;

  @ExcelProperty(value = "广告费")
  private java.math.BigDecimal totalAdsCost;

  @ExcelProperty(value = "推广费")
  private java.math.BigDecimal promotionFee;

  @ExcelProperty(value = "FBA仓储费")
  private java.math.BigDecimal totalStorageFee;

  @ExcelProperty(value = "FBA国际物流货运费")
  private java.math.BigDecimal sharedFbaIntegerernationalInboundFee;

  @ExcelProperty(value = "调整费用")
  private java.math.BigDecimal adjustments;

  @ExcelProperty(value = "平台其他费")
  private java.math.BigDecimal totalPlatformOtherFee;

  @ExcelProperty(value = "销售税")
  private java.math.BigDecimal totalSalesTax;

  @ExcelProperty(value = "销售税退款额")
  private java.math.BigDecimal salesTaxRefund;

  @ExcelProperty(value = "市场税")
  private java.math.BigDecimal salesTaxWithheld;

  @ExcelProperty(value = "市场税退款额")
  private java.math.BigDecimal refundTaxWithheld;

  @ExcelProperty(value = "混合网路费用")
  private java.math.BigDecimal tdsSection194ONet;

  @ExcelProperty(value = "采购成本")
  private java.math.BigDecimal cgPriceTotal;

  @ExcelProperty(value = "采购单价")
  private java.math.BigDecimal cgUnitPrice;

  @ExcelProperty(value = "采购占比")
  private java.math.BigDecimal proportionOfCg;

  @ExcelProperty(value = "头程成本")
  private java.math.BigDecimal cgTransportCostsTotal;

  @ExcelProperty(value = "头程单价")
  private java.math.BigDecimal cgTransportUnitCosts;

  @ExcelProperty(value = "头程占比")
  private java.math.BigDecimal proportionOfCgTransport;

  @ExcelProperty(value = "合计成本")
  private java.math.BigDecimal totalCost;

  @ExcelProperty(value = "其他成本")
  private java.math.BigDecimal cgOtherCostsTotal;

  @ExcelProperty(value = "毛利润")
  private java.math.BigDecimal grossProfit;

  @ExcelProperty(value = "毛利率")
  private java.math.BigDecimal grossRate;
}
